using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DangKyDAO
/// </summary>
public class DangKyDAO:DataProvider
{
	public DangKyDAO()
	{
		
	}

    public DataTable DSLuanVanDangKy()
    {
        connect();
        DataTable table = new DataTable();

        try
        {
            SqlCommand cmd = new SqlCommand("sp_Select_LuanVan_DangKy", strCnn);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter sqlapater = new SqlDataAdapter(cmd);
            sqlapater.Fill(table);
            sqlapater.Dispose();
        }
        catch (Exception es)
        {
            throw es;
        }
        return table;
    }
}
